
begin tran
delete begin_qty
declare @a nvarchar(100)
insert into begin_qty (sku, qty) 
select sku sku,  qty qty from 
OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=F:\update_sku\FG Movement Report.xls',begin_qty$)
delete begin_qty where isnull(sku, '') = '' or isnull(qty, '') = '' 

select * from begin_qty
commit tran


